You can easily import & synchronize data from a wide range of data sources into Zoho Reports for reporting & analysis. This includes Files, Feeds, Cloud Drives, Local & Cloud databases, NoSQL, Popular Business Applications, Your custom made applications etc..,
Know more about the featured list of data connectors
The screenshot below corresponds to importing data in a CSV file from your local drive.
Type in a name for the database you want to create. Providing description is optional. You can browse & load the file directly from your local drive or copy-paste the data using the 'Pasted Data' option. You can also import data directly from web URL feeds using the 'Web' option.
Check out the help documentation page on how to import data into Zoho Reports. Watch demo.
Data is stored in entities called 'Tables'. You should provide a table name for the data imported into Zoho Reports.
You can also change the 'First Row Contains Column Names' setting if needed. If the data imported contains any time/date values, Zoho Reports will automatically identify the format. You can also set your own date format.
While importing the CSV file, you also have customizing options like modifying the delimiter separating your columns, skipping the top n rows, specifying the comment character etc.
As shown below, Zoho Reports automatically takes the values in the first row of the imported file and lists them as column names (Date, Region, Product Category, Product etc. in this case). The first 4 rows from the file are shown as preview.
Import summary of the data imported into Zoho Reports.
The screenshot below, shows the data imported into the spreadsheet like interface of Zoho Reports.