How to manually convert Excel to a Markdown table

2024-08-02

Short version

Copy the table from Excel.
Paste it into a Markdown table generator.
Adjust as needed and copy back.

Long version

1. Copy the Table From Excel

Highlight the entire table in Excel that you wish to convert. Right-click and select Copy or use the shortcut Ctrl+C (Windows) or Cmd+C (Mac).

2. Use a Markdown Table Generator

Visit an online Markdown table generator such as tableconvert.com or any other tool. Paste your copied data into the input area.

3. Adjust the Output

The generator will convert the Excel data to a Markdown table format. Review the output to ensure it looks correct; you may need to adjust column widths or formatting if required.

4. Copy the Markdown Table

Once satisfied, copy the Markdown code provided by the generator. It should look similar to this:

| Name | Age | Location |
|------|-----|----------|
| John | 30  | USA      |
| Jane | 25  | Canada   |

5. Use In Your Markdown Document

Finally, paste the copied Markdown table into your Markdown document at the desired location. This will ensure your Excel data is now formatted as a Markdown table.