# How can I reconcile from my own CSV file?

**URL:** <https://forum.openrefine.org/t/how-can-i-reconcile-from-my-own-csv-file/777>\
**Category:** Support and Helpdesk\
**Tags:** reconciliation\
**Created:** [May 29, 2023, 11:59am UTC](https://forum.openrefine.org/t/how-can-i-reconcile-from-my-own-csv-file/777 "2023-05-29T11:59:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dqlearner](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/dqlearner/32/232_2.png) [@dqlearner](https://forum.openrefine.org/u/dqlearner)\
**Post date:** [May 29, 2023, 11:59am UTC](https://forum.openrefine.org/t/how-can-i-reconcile-from-my-own-csv-file/777/1 "2023-05-29T11:59:21Z")

</div>

Looks like there isn’t any functional data reconciliation from my own file (CSV/Excel) etc. Is there any alternative or workaround?

Can I host a Json file in web application (for example with LAMP stack) and try to connect there?

---

<div class="post-metadata">

**Author:** ![Martin](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/martin/32/7_2.png) [@Martin](https://forum.openrefine.org/u/Martin)\
**Post date:** [May 29, 2023, 7:56pm UTC](https://forum.openrefine.org/t/how-can-i-reconcile-from-my-own-csv-file/777/2 "2023-05-29T19:56:05Z")

</div>

@dqlearner the community released several local services to build your own reconciliation service. We listed them on the wiki here [Reconcilable Data Sources · OpenRefine/OpenRefine Wiki · GitHub](https://github.com/OpenRefine/OpenRefine/wiki/Reconcilable-Data-Sources#local-services)

Today [CSV Reconcile](https://github.com/gitonthescene/csv-reconcile) is the most advanced csv reconciliation service. If you want to build your own server [conciliator](https://github.com/codeforkjeff/conciliator) can be a good starting point.

---

<div class="post-metadata">

**Author:** ![thadguidry](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/thadguidry/32/653_2.png) [@thadguidry](https://forum.openrefine.org/u/thadguidry)\
**Post date:** [May 30, 2023, 12:33am UTC](https://forum.openrefine.org/t/how-can-i-reconcile-from-my-own-csv-file/777/3 "2023-05-30T00:33:11Z")

</div>

Reconciling (matching) same or similar entities in general can have different ways of putting same entities together in close proximity to each other. Getting things close or next to each other then becomes the real task. There are various approaches.

Sometimes matching string similar or duplicate items in OpenRefine can be done with alternative ways depending on a users needs:

1. Sort permanently on a column (clusters occur through natural alphabetical order)
2. Use `cross()` to do lookups from one column to another column in the same project and joining with a separator such as 3 pipes `|||`
3. Use deduplicate facet and export the facets contents
4. based on string similarity and something our Clustering algorithms can help with.

---

<div class="post-metadata">

**Author:** ![dqlearner](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/dqlearner/32/232_2.png) [@dqlearner](https://forum.openrefine.org/u/dqlearner)\
**Post date:** [May 31, 2023, 7:20pm UTC](https://forum.openrefine.org/t/how-can-i-reconcile-from-my-own-csv-file/777/4 "2023-05-31T19:20:07Z")

</div>

thank you for the info. Still learning and hope to apply your approach.