Skip to main content
A CSV (comma-separated values) file stores data in a table structure, with each row on a new line and each value separated by a comma. CSV files are widely used for importing contact tables, uploading data to tools like Lusha, and managing large datasets. You can create one using Microsoft Excel, OpenOffice Calc, or Google Sheets.

How to create a CSV file

1

Open a new spreadsheet

Open a new spreadsheet in Excel, OpenOffice Calc, or Google Sheets.
2

Add column headers

In row 1, type your column headers - for example: First Name, Last Name, Email, Company.
3

Enter your data

Enter your data in the rows below each header.
4

Open Save As

Click File → Save As. (In Google Sheets, go to File → Download as.)
5

Select CSV as the file type

From the file type dropdown, select CSV.
Selecting CSV as the file type when saving a spreadsheet
6

Save the file

Click Save. Commas will automatically be added between each value.
Your file is now ready to upload.