Exporting a CSV

How to export CSV from Excel

1. Open your spreadsheet in Microsoft Excel.
2. Go to File → Save As (on Mac: File → Export).
3. Choose the file format CSV (Comma delimited) (*.csv).
4. Click Save. Your CSV file is ready to upload.

If Excel asks whether to keep the current format, click Keep Current Format. Only the active sheet is exported — make sure your data is on the active sheet before saving.

How to export CSV from Google Sheets

1. Open your spreadsheet in Google Sheets.
2. Go to File → Download.
3. Choose Comma-separated values (.csv). The file downloads immediately.

Google Sheets exports the currently active sheet as UTF-8 by default — no encoding changes needed. If your spreadsheet has multiple sheets, export each one separately. For the full workflow, see Google Sheets to API.

Quick troubleshooting

• Wrong delimiter — API Butler expects comma-separated values. If you exported with semicolons or tabs, re-export and choose the CSV (Comma) format.
• Missing header row — The first row becomes your column names in the API. Make sure it contains meaningful headers, not data.
• Encoding issues — In Excel, choose CSV UTF-8 (Comma delimited) if that option is available. Google Sheets exports UTF-8 automatically.
• Multiple sheets — Only the active sheet is exported. Duplicate data to one sheet first if needed.

Next steps

Once you have your CSV file, upload it on the home page to generate your API in seconds. Before uploading, check the CSV format requirements to make sure your file is structured correctly. New to API Butler? See the getting started guide.